DEBUG: query: set datestyle to 'ISO'; select version(), case when pg_encoding_to_char(1) = 'SQL_ASCII' then 'UNKNOWN' else getdatabaseencoding() end; DEBUG: ProcessUtility: set datestyle to 'ISO'; select version(), case when pg_encoding_to_char(1) = 'SQL_ASCII' then 'UNKNOWN' else getdatabaseencoding() end; DEBUG: query: begin; DEBUG: ProcessUtility: begin; DEBUG: query: SELECT t1_m.mountain_id FROM ejb_mountain t1_m DEBUG: query: SELECT mountain_id,mountain_name, location, king_id FROM ejb_mountain WHERE (mountain_id=1) OR (mountain_id=3) OR (mountain_id=2) DEBUG: query: SELECT dwarf_id,dwarf_name, born, home_id, spouse_id FROM ejb_dwarf WHERE (dwarf_id=1) OR (dwarf_id=2) OR (dwarf_id=3) OR (dwarf_id=4) OR (dwarf_id=5) OR (dwarf_id=8) OR (dwarf_id=6) OR (dwarf_id=7) DEBUG: query: UPDATE ejb_mountain SET king_id=7 WHERE mountain_id=2 DEBUG: query: SELECT 1 FROM ONLY "ejb_dwarf" WHERE "dwarf_id" = $1 FOR UPDATE OF "ejb_dwarf" DEBUG: query: UPDATE ejb_dwarf SET home_id=2, spouse_id=8 WHERE dwarf_id=7 DEBUG: query: SELECT 1 FROM ONLY "ejb_mountain" WHERE "mountain_id" = $1 FOR UPDATE OF "ejb_mountain" DEBUG: query: SELECT 1 FROM ONLY "ejb_dwarf" WHERE "dwarf_id" = $1 FOR UPDATE OF "ejb_dwarf" DEBUG: query: commit;begin; DEBUG: ProcessUtility: commit;begin; DEBUG: ProcessUtility: commit;begin; DEBUG: query: rollback; begin; DEBUG: ProcessUtility: rollback; begin; DEBUG: ProcessUtility: rollback; begin; DEBUG: query: SELECT t1_d.dwarf_id FROM ejb_dwarf t1_d DEBUG: query: SELECT dwarf_id,dwarf_name, born, home_id, spouse_id FROM ejb_dwarf WHERE (dwarf_id=1) OR (dwarf_id=2) OR (dwarf_id=3) OR (dwarf_id=4) OR (dwarf_id=5) OR (dwarf_id=8) OR (dwarf_id=6) OR (dwarf_id=7) DEBUG: query: SELECT mountain_id,mountain_name, location, king_id FROM ejb_mountain WHERE (mountain_id=1) OR (mountain_id=3) OR (mountain_id=2) DEBUG: query: UPDATE ejb_dwarf SET home_id=1 WHERE dwarf_id=2 DEBUG: query: UPDATE ejb_dwarf SET home_id=1 WHERE dwarf_id=3 DEBUG: query: UPDATE ejb_dwarf SET home_id=1 WHERE dwarf_id=4 DEBUG: query: UPDATE ejb_dwarf SET home_id=2 WHERE dwarf_id=5 DEBUG: query: UPDATE ejb_mountain SET king_id=7 WHERE mountain_id=2 DEBUG: query: UPDATE ejb_dwarf SET home_id=2, spouse_id=7 WHERE dwarf_id=8 DEBUG: query: UPDATE ejb_dwarf SET home_id=2, spouse_id=8 WHERE dwarf_id=7 DEBUG: query: UPDATE ejb_dwarf SET home_id=2 WHERE dwarf_id=6 DEBUG: query: commit;begin; DEBUG: ProcessUtility: commit;begin; DEBUG: ProcessUtility: commit;begin; DEBUG: query: rollback; begin; DEBUG: ProcessUtility: rollback; begin; DEBUG: ProcessUtility: rollback; begin;